package sopt.dev.db;

import static sopt.dev.db.CityInfoDB.CityDBScheme;

/**
 * Created by Dev on 13. 8. 3.
 */
public class CityDBCreator implements IDBCreator {


	@Override
	public String[] getCreateTableStmt() {
		/*
        Create table : DDL
		 */
		final String CITY_TABLE_CREATE_STMT = "CREATE TABLE "
				+ CityDBScheme.TABLE_NAME + " ("
				+ CityDBScheme.COLUMN_ID + " INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "
				+ CityDBScheme.COLUMN_CITYNAME + " TEXT, "
				+ CityDBScheme.COLUMN_INDATE + " TEXT, "
				+ CityDBScheme.COLUMN_OUTDATE + " TEXT, "
				+ CityDBScheme.COLUMN_IMG_PATH + " TEXT,"
				+ CityDBScheme.COLUMN_CURRENCY + " TEXT );";

		return new String[]{ CITY_TABLE_CREATE_STMT };
	}

	@Override
	public String[] getInitDataStmt() {
		return new String[0];
	}
}
